--DataMine
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.DATAMINE.DEFAULT'),
 'MR','*' ,'MR_IPTDS_DATAMINE_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DATAMINE_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.DATAMINE.DEFAULT'),
 'CT','*' ,'CT_IPTDS_DATAMINE_DEFAULT' ,
(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DATAMINE_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.DATAMINE.DEFAULT'),
 'MR','*' ,'MR_HTTP_DATAMINE_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DATAMINE_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.DATAMINE.DEFAULT'),
 'CT','*' ,'CT_HTTP_DATAMINE_DEFAULT' ,
(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'DATAMINE_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

-- RELI *.PD_FTS_01.RELI
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'CT','*' ,'CT_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'MR','*' ,'MR_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'NM','*' ,'NM_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'NPAS','*' ,'NPAS_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'PET','*' ,'PET_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'UL','*' ,'UL_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'VMX','*' ,'VMX_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'XR','*' ,'XR_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'CT','*' ,'CT_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'MR','*' ,'MR_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'NM','*' ,'NM_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'NPAS','*' ,'NPAS_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'PET','*' ,'PET_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'UL','*' ,'UL_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'VMX','*' ,'VMX_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'XR','*' ,'XR_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'CT','*' ,'CT_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'MR','*' ,'MR_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'NM','*' ,'NM_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'NPAS','*' ,'NPAS_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'PET','*' ,'PET_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'UL','*' ,'UL_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'VMX','*' ,'VMX_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.RELI'),
 'XR','*' ,'XR_IPTDS_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'CT','*' ,'CT_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'MR','*' ,'MR_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'NM','*' ,'NM_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'NPAS','*' ,'NPAS_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'PET','*' ,'PET_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'UL','*' ,'UL_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'VMX','*' ,'VMX_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.RELI'),
 'XR','*' ,'XR_HTTP_PD_FTS_01_RELI_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_RELI_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


--RELI *.PD_FTS_01.APPSVC_PETHP
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'CT','*' ,'CT_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'MR','*' ,'MR_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'NM','*' ,'NM_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'NPAS','*' ,'NPAS_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'PET','*' ,'PET_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'UL','*' ,'UL_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'VMX','*' ,'VMX_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_FTS_01.APPSVC_PETHP'),
 'XR','*' ,'XR_IPTDS_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'CT','*' ,'CT_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'MR','*' ,'MR_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'NM','*' ,'NM_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'NPAS','*' ,'NPAS_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'PET','*' ,'PET_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'UL','*' ,'UL_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'VMX','*' ,'VMX_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_FTS_01.APPSVC_PETHP'),
 'XR','*' ,'XR_HTTP_PD_FTS_01_APPSVC_PETHP_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDFTS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


--RELI *.PD_RDA.DEFAULT
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'CT','*' ,'CT_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'MR','*' ,'MR_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'NM','*' ,'NM_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'NPAS','*' ,'NPAS_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'PET','*' ,'PET_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'UL','*' ,'UL_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'VMX','*' ,'VMX_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_RDA.DEFAULT'),
 'XR','*' ,'XR_HTTP_IPTDS_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'CT','*' ,'CT_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'MR','*' ,'MR_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'NM','*' ,'NM_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'NPAS','*' ,'NPAS_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'PET','*' ,'PET_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'UL','*' ,'UL_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'VMX','*' ,'VMX_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_RDA.DEFAULT'),
 'XR','*' ,'XR_HTTP_PD_RDA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'RDA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


-- SHEM
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.ALARM'),
 'MR','*' ,'MR_IPTDS_ALARM_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEMALARM_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.ALARM'),
 'MR','*' ,'MR_HTTP_ALARM_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEMALARM_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.FILL_NOTIFICATION'),
 'MR','*' ,'MR_IPTDS_FILL_NOTIFICATION_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'FILL_NOTIFICATION_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.FILL_NOTIFICATION'),
 'MR','*' ,'MR_HTTP_FILL_NOTIFICATION_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'FILL_NOTIFICATION_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.STUCK_FILL'),
 'MR','*' ,'MR_IPTDS_STUCK_FILL_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'STUCK_FILL_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.STUCK_FILL'),
 'MR','*' ,'MR_HTTP_STUCK_FILL_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'STUCK_FILL_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.STUCK_UNBLANK'),
 'MR','*' ,'MR_IPTDS_STUCK_UNBLANK_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'STUCK_UNBLANK_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.STUCK_UNBLANK'),
 'MR','*' ,'MR_HTTP_STUCK_UNBLANK_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'STUCK_UNBLANK_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);
 
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.ABANDONED'),
 'MR','*' ,'MR_IPTDS_ABANDONED_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ABANDONED_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365); 

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.ABANDONED'),
 'MR','*' ,'MR_HTTP_ABANDONED_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ABANDONED_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.QUENCH'),
 'MR','*' ,'MR_IPTDS_QUENCH_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'QUENCH_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);
 
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.QUENCH'),
 'MR','*' ,'MR_HTTP_QUENCH_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'QUENCH_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365); 
 
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.COMPRESSOR'),
 'MR','*' ,'MR_IPTDS_COMPRESSOR_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'COMPRESSOR_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365); 

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.COMPRESSOR'),
 'MR','*' ,'MR_HTTP_COMPRESSOR_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'COMPRESSOR_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.METERERROR'),
 'MR','*' ,'MR_IPTDS_METERERROR_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'METERERROR_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);
 
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.METERERROR'),
 'MR','*' ,'MR_HTTP_METERERROR_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'METERERROR_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365); 

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.LATCHEDDATA'),
 'MR','*' ,'MR_IPTDS_LATCHEDDATA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'LATCHEDDATA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);
 
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.LATCHEDDATA'),
 'MR','*' ,'MR_HTTP_LATCHEDDATA_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'LATCHEDDATA_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365); 

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.SHEM_CALL.DEFAULT'),
 'MR','*' ,'MR_IPTDS_SHEM_CALL_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.SHEM_CALL.DEFAULT'),
 'MR','*' ,'MR_HTTP_SHEM_CALL_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'SHEM_CALL_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

Insert into AUTOSC.CFG_REQUEST_DEFN
   (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON)
 Values
   (AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval, 
   		(SELECT request_type_id FROM AUTOSC.cfg_request_type WHERE request_type_name = 'checkin'),
   		'MR', '*', 'mmchckin', 
   		(SELECT task_type_id FROM AUTOSC.cfg_task_type WHERE task_type_name = 'SHEM_CHECK'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

-- SHEM Check
Insert into AUTOSC.CFG_REQUEST_DEFN
   (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON)
 Values
   (AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval, 
   		(SELECT request_type_id FROM AUTOSC.cfg_request_type where request_type_name = 'mmfetch'), 
   		'MR', '*', 'fetch', 
   		(SELECT task_type_id FROM AUTOSC.cfg_task_type WHERE task_type_name = 'SHEM_CHECK'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);   		

-- Prodiags Schedule Update
Insert into AUTOSC.CFG_REQUEST_DEFN
   (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON)
 Values
   (AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval, 
   		(SELECT request_type_id FROM AUTOSC.cfg_request_type where request_type_name = 'PRODIAGS.SCHEDULE_UPDATE'), 
   		'MR', '*', 'prodiags schedule update', 
   		(SELECT task_type_id FROM AUTOSC.cfg_task_type WHERE task_type_name = 'ONWATCH_TASK'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);;

Insert into AUTOSC.CFG_REQUEST_DEFN
   (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON)
 Values
   (AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval, 
   		(SELECT request_type_id FROM AUTOSC.cfg_request_type where request_type_name = 'PRODIAGS.SCHEDULE_UPDATE'), 
   		'CT', '*', 'prodiags schedule update', 
   		(SELECT task_type_id FROM AUTOSC.cfg_task_type WHERE task_type_name = 'ONWATCH_TASK'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);;

Insert into AUTOSC.CFG_REQUEST_DEFN
   (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON)
 Values
   (AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval, 
   		(SELECT request_type_id FROM AUTOSC.cfg_request_type where request_type_name = 'PRODIAGS.SCHEDULE_UPDATE'), 
   		'XR', '*', 'prodiags schedule update', 
   		(SELECT task_type_id FROM AUTOSC.cfg_task_type WHERE task_type_name = 'ONWATCH_TASK'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);;

Insert into AUTOSC.CFG_REQUEST_DEFN
   (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON)
 Values
   (AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval, 
   		(SELECT request_type_id FROM AUTOSC.cfg_request_type where request_type_name = 'PRODIAGS.SCHEDULE_UPDATE'), 
   		'PET', '*', 'prodiags schedule update', 
   		(SELECT task_type_id FROM AUTOSC.cfg_task_type WHERE task_type_name = 'ONWATCH_TASK'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

-- Insite Auto Checkout
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'CT','*' ,'CT_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'MR','*' ,'MR_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'NM','*' ,'NM_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'NPAS','*' ,'NPAS_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'PET','*' ,'PET_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'UL','*' ,'UL_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'VMX','*' ,'VMX_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.INSITE_AUTOCHECKOUT.DEFAULT'),
 'XR','*' ,'XR_INSITE_AUTOCHECKOUT_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'ISAUTOCHECKOUT_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

-- Healthpage
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.CT_HEALTHPG.DEFAULT'),
 'CT','*' ,'CT_IPTDS_CT_HEALTHPG_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'HEALTHPG_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.CT_HEALTHPG.DEFAULT'),
 'CT','*' ,'CT_IPTDS_CT_HEALTHPG_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'HEALTHPG_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.MR_HEALTHPG.DEFAULT'),
 'MR','*' ,'MR_IPTDS_MR_HEALTHPG_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'HEALTHPG_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.MR_HEALTHPG.DEFAULT'),
 'MR','*' ,'MR_IPTDS_MR_HEALTHPG_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'HEALTHPG_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);
 
 
-- Notify Service (PD_NS_01)
INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'CT','*' ,'CT_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'CT','*' ,'CT_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'MR','*' ,'MR_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'MR','*' ,'MR_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'NM','*' ,'NM_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'NM','*' ,'NM_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'NPAS','*' ,'NPAS_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'NPAS','*' ,'NPAS_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'PET','*' ,'PET_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'PET','*' ,'PET_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'UL','*' ,'UL_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'UL','*' ,'UL_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'VMX','*' ,'VMX_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'VMX','*' ,'VMX_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'PRODIAGS.PD_NS_01.DEFAULT'),
 'XR','*' ,'XR_HTTP_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (
   REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, 
   MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, VERIFIER, REQUESTER, EXPIRES_ON) 
VALUES ( AUTOSC.CFG_REQUEST_DEFN_SEQ.nextval,
(SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME = 'IPTDS.PD_NS_01.DEFAULT'),
 'XR','*' ,'XR_IPTDS_PDNS01_DEFAULT' , 
 (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME = 'PDNS01_FT'), 'faichun.siu@ge.com', 'faichun.siu@ge.com', sysdate + 365);


COMMIT;